


class Msk:
	def __init__(self):
		mysqldb = mysql.connector.connect(user = 'admins',passwd = '123',host = '192.168.0.110',database = 'user_system',buffered = True)#mysql服务器信息
		self.mydb = mysqldb.cursor()#设置游标
	
	def ml_1(self):
		self.mydb.execute('CREATE TABLE user_information(user_id INT(96) NOT NULL AUTO_INCREMENT,user_name VARCHAR(128) NOT NULL,user_passwd VARCHAR(128) NOT NULL,user_tel INT(15) NOT NULL,user_mail VARCHAR(128) NOT NULL,PRIMARY KEY (user_id))ENGINE = InnoDB')
		ins = "INSERT INTO user_information(user_name,user_passwd,user_tel,user_mail) VALUES (%s,%s,%s,%s)"
		data = ("admin","123","3411","sda@qq.com")
		self.mydb.execute(ins,data)#插入数据
		mysqldb.commit()#更新数据库
		self.mydb.close()
		print(mydb.rowcount,"插入成功")
		
object=Msk()





















'''
class Sign_in :
	def __init__(*self):
	
	def Validate_Logon(*self):
	
		var1 = self[0]
		var2 = self[1]
		if var1 != '' and var2 != '':
			return "不为空"
'''